<html>
<body>
<h1> TABLA ZOO </h1>
<br>
<table border cellpadding=8>
<tr><td><b>ID_ZOO</b></td><td><b>NOMBRE</b></td><td><b>CIUDAD</b></td><td><b>AFORO</b></td><td><b>PAIS</b></td><td><b>IDIOMA</b></td></tr>
<tr><td>Z-0002</td><td>Zoo Barcelona</td><td>Barcelona</td><td>300000</td><td>Espana</td><td>Castellano</td></tr>
<tr><td>Z-0003</td><td>Zoo Paris</td><td>Paris</td><td>150000</td><td>Francia</td><td>Frances</td></tr>
<tr><td>Z-0004</td><td>Central Park Zoo</td><td>Nueva York</td><td>400000</td><td>Estados Unidos</td><td>Ingles</td></tr>
<tr><td>Z-0005</td><td>Zoo Sidney</td><td>Sidney</td><td>250000</td><td>Australia</td><td>Ingles</td></tr>
<tr><td>Z-0006</td><td>Zoo Manchester</td><td>Manchester</td><td>100000</td><td>Inglaterra</td><td>Ingles</td></tr>
<tr><td>Z-0007</td><td>Zoo Dublin</td><td>Dublin</td><td>200000</td><td>Irlanda</td><td>Ingles</td></tr>
<tr><td>Z-0001</td><td>Zoo Madrid</td><td>Madrid</td><td>200000</td><td>Espana</td><td>Castellano</td></tr>
</table>


<h1> TABLA SALA </h1>
<br>
<table border cellpadding=8>
<tr><td><b>ID_SALA</b></td><td><b>AFORO_SALA</b></td><td><b>NOMBRE_SALA</b></td><td><b>ZOO</b></td></tr>
<tr><td>S-0003</td><td>300</td><td>Delfinario</td><td>Z-0001</td></tr>
<tr><td>S-0004</td><td>400</td><td>Animales marinos</td><td>Z-0002</td></tr>
<tr><td>S-0005</td><td>260</td><td>Delfinario</td><td>Z-0003</td></tr>
<tr><td>S-0006</td><td>155</td><td>Aves</td><td>Z-0004</td></tr>
<tr><td>S-0007</td><td>50</td><td>Granja</td><td>Z-0001</td></tr>
<tr><td>S-0008</td><td>55</td><td>Granja</td><td>Z-0003</td></tr>
<tr><td>S-0009</td><td>200</td><td>Acuario</td><td>Z-0004</td></tr>
<tr><td>S-0010</td><td>300</td><td>Aves</td><td>Z-0005</td></tr>
<tr><td>S-0001</td><td>150</td><td>Acuario</td><td>Z-0006</td></tr>
<tr><td>S-0002</td><td>220</td><td>Acuario</td><td>Z-0007</td></tr>
</table>


<h1> TABLA ANIMAL </h1>
<br>
<table border cellpadding=8>
<tr><td><b>NOMBRE</b></td><td><b>ESPECIE</b></td><td><b>EDAD</b></td><td><b>DESCRIPCION</b></td><td><b>PAIS</b></td><td><b>EXISTINCION</b></td><td><b>ENFERMEDAD</b></td><td><b>SALA</b></td></tr>
<tr><td>Chin-Lui</td><td>Pandas</td><td>5</td><td> - </td><td>China</td><td>NO</td><td>ninguna</td><td> - </td></tr>
<tr><td>Bagueera</td><td>Zebra</td><td>13</td><td> - </td><td>Etipopia</td><td>NO</td><td>ninguna</td><td> - </td></tr>
<tr><td>Punta</td><td>Tigre de Bengala</td><td>10</td><td> - </td><td>India</td><td>SI</td><td>ninguna</td><td> - </td></tr>
<tr><td>Jota</td><td>Jabali</td><td>4</td><td> - </td><td>Espana</td><td>NO</td><td>ninguna</td><td> - </td></tr>
<tr><td>Wolverine</td><td>Lobo</td><td>3</td><td> - </td><td>Espana</td><td>NO</td><td>ninguna</td><td> - </td></tr>
<tr><td>Mirella</td><td>Delfin</td><td>7</td><td> - </td><td>EEUU</td><td>NO</td><td>ninguna</td><td> - </td></tr>
<tr><td>Lobo</td><td>Leon Marino</td><td>17</td><td> - </td><td>Galapagos</td><td>NO</td><td>ninguna</td><td> - </td></tr>
<tr><td>Miterrant</td><td>Pinguino</td><td>12</td><td> - </td><td>Antartida</td><td>NO</td><td>resfriado</td><td> - </td></tr>
<tr><td>Ramiro</td><td>Oso</td><td>20</td><td> - </td><td>EEUU</td><td>SI</td><td>ninguna</td><td> - </td></tr>
</table>


<h1> TABLA HORARIO </h1>
<br>
<table border cellpadding=8>
<tr><td><b>FECHA</b></td><td><b>NOMBRE</b></td><td><b>ESPECIE</b></td><td><b>TIPO_COMIDA</b></td></tr>
<tr><td>2009-11-04 00:00:00</td><td>Bagueera</td><td>Zebra</td><td>verde</td></tr>
<tr><td>2009-11-10 00:00:00</td><td>Ramiro</td><td>Oso</td><td>bambu</td></tr>
<tr><td>2009-11-12 00:00:00</td><td>Wolverine</td><td>Lobo</td><td>carne</td></tr>
<tr><td>2009-11-11 00:00:00</td><td>Wolverine</td><td>Lobo</td><td>carne</td></tr>
</table>


<h1> TABLA CUIDA </h1>
<br>
<table border cellpadding=8>
<tr><td><b>NOMBRE</b></td><td><b>ESPECIE</b></td><td><b>ID_EMPLEADO</b></td><td><b>FECHA</b></td></tr>
<tr><td>Bagueera</td><td>Zebra</td><td>C-0001</td><td>2009-11-07 00:00:00</td></tr>
<tr><td>Chin-Lui</td><td>Pandas</td><td>C-0002</td><td>2009-11-07 00:00:00</td></tr>
<tr><td>Mirella</td><td>Delfin</td><td>C-0003</td><td>2009-11-08 00:00:00</td></tr>
</table>


<h1> TABLA CUIDADOR </h1>
<br>
<table border cellpadding=8>
<tr><td><b>ID_EMPLEADO</b></td><td><b>NOMBRE</b></td><td><b>APELLIDO1</b></td><td><b>APELLIDO2</b></td><td><b>TELEFONO</b></td><td><b>EDAD</b></td><td><b>ESPECIALIDAD</b></td><td><b>ESTADO</b></td></tr>
<tr><td>C-0001</td><td>Maria</td><td>Lopez</td><td>Martin</td><td>612345199</td><td>35</td><td>Herpetologia</td><td>Trabajando</td></tr>
<tr><td>C-0002</td><td>Jaime</td><td>Garcia</td><td>Moron</td><td>678901234</td><td>28</td><td>Ornitologia</td><td>Trabajando</td></tr>
<tr><td>C-0003</td><td>Juan</td><td>Hernandez</td><td>Artilleros</td><td>609876543</td><td>51</td><td>Nutricion animal</td><td>Trabajando</td></tr>
<tr><td>C-0004</td><td>Sara</td><td>Espina</td><td>Mateos</td><td>654321981</td><td>25</td><td>Herpetologia</td><td>Vacaciones</td></tr>
<tr><td>C-0005</td><td>Javier</td><td>Gonzalez</td><td>Silva</td><td>676123097</td><td>41</td><td>Mastozologia</td><td>Vacaciones</td></tr>
<tr><td>C-0006</td><td>Marta</td><td>Pelayo</td><td>Rodriguez</td><td>676754334</td><td>32</td><td>Mastozologia</td><td>Trabajando</td></tr>
<tr><td>C-0007</td><td>Alonso</td><td>Martinez</td><td>Paz</td><td>610927346</td><td>26</td><td>Ornitologia</td><td>Trabajando</td></tr>
<tr><td>C-0008</td><td>Estrella</td><td>Osuna</td><td>Arias</td><td>634586739</td><td>39</td><td>Nutricion animal</td><td>Trabajando</td></tr>
</table>


<h1> TABLA TICKETS </h1>
<br>
<table border cellpadding=8>
<tr><td><b>ID_ZOO</b></td><td><b>TIPO</b></td><td><b>PRECIO</b></td></tr>
<tr><td>Z-0001</td><td>adulto</td><td>10?</td></tr>
<tr><td>Z-0002</td><td>nino</td><td>4?</td></tr>
<tr><td>Z-0003</td><td>adulto</td><td>12?</td></tr>
<tr><td>Z-0001</td><td>nino</td><td>3?</td></tr>
</table>


</body>
</html>
